The information provided here for the midterm test will supersede any previous announcements/instructions.

1. Information

  • Date: March 5 (Friday)

  • Venues: Multi-Purpose Sports Halls 1 & 2 (MPSH1 & MPSH2)

    • Each hall is partitioned into 5 sections with a seating capacity of 48 for each section

      • MPSH 1: MPSH1A, MPSH1B, MPSH1C, MPSH1D, MPSH1E (ground level)

      • MPSH 2: MPSH2A, MPSH2B, MPSH2C, MPSH2D, MPSH2E (level 2)

    • Each student will be assigned to a specific seat in a hall section (to be announced later)

    • Students to enter & leave assigned sections using designated doors

MPSH-1
Figure 1. Source: streetdirectory.com
SportsCentre
Figure 2. NUS Sports Centre
Entrance
Figure 3. Road to MSPH
MPSH-1
MPSH-2
MPSH-2
Figure 4. MPSH1A & MPSH1B

  • Duration: 90 minutes

    • Students will be admitted into test venue from 11:45am

    • Test will start at 12:15pm and end at 1:45pm

    • Latecomers will be not be granted any extra time for the test

    • Students who are late by more than 30 minutes (i.e., after 12:45pm) will not be allowed to sit for the test and will receive 0 marks for the test

    • Students will not be allowed to leave the test venue during the last 15 minutes (i.e., after 1:30pm).

  • Scope of midterm test

    • Lecture 1: Relational Data Model (up to slide number 21)

    • Lecture 2: Relational Algebra

    • Lecture 3: SQL 1

    • Lecture 4: Entity-Relationship Model

  • Test format

    • Test conducted using Examplify in lockdown mode

      • No access to Internet

      • No access to other application besides Examplify

      • Laptop’s wifi will be enabled when uploading submission

    • Closed-book test

      • Allowed to bring one double-sided A4-sized sheet of notes (printed or handwritten)

    • Consists of the following question types:

      • Multiple-choice questions

      • Multiple-response questions

      • Essay questions (e.g., relational algebra queries)

    • Answers requiring relational algebra queries must be written using the same syntax used in assignment 1

      • Valid syntax: select{hours > 10 and pid = 100}(Works)

      • Invalid syntax: select ra('select{hours > 10 and pid = 100}(Works)');

2. Laptops

  • Students must not use Apple’s M1-based laptops

  • Students must fully charge your laptop before the test

    • Your fully charged laptop must last for at least 90 minutes

  • If you have requested for a laptop loan, you should have been notified by SoC technical service

    • If not, please contact the lecturer ASAP

    • Do test that Examplify is working on the loaned laptop

  • If you have indicated that your laptop requires constant charging, you should have received an email from the lecturer on being seated at a charging station

    • If not, please contact the lecturer ASAP

3. March 4 (Thursday): Download test paper

  • Examplify test paper will be available for download on March 4 from 1pm onwards.

  • Students must download the test paper onto laptop by 10pm on March 4.

  • You must download the test paper onto the laptop that will be used for the test

    • You can download the test paper only once

4. What to bring for the test

  • Student card

  • Phone with uNivUS app installed

  • Fully-charged laptop

    • Examplify installed on laptop

    • Examplify test paper downloaded on laptop

  • Laptop power adapter

  • One double-sided A4-sized sheet of notes (printed or handwritten)

  • Pen / pencil

  • No calculator is required for the test

  • Remember your assigned hall section & seat number

  • Don’t forget to wear your face mask!

5. Admission into venue

  • Each venue section has a designated door for entrance & exit

    • Look out for door’s signage

  • Students are required to make your health declaration before entering campus

  • Students are required to wear a face mask during the test. Students without a face mask will not be admitted into the test venue

  • Students must show the green pass on the uNivUS app before being admitted into the test venue

  • Latecomers to wait outside the door if the invigilator is not at the door

  • Latecomers will have to stop writing at the end of the test even if your timer has not counted down to zero

  • Students who are late by more than 30 minutes (i.e., after 12:45pm) will not be allowed to sit for the test and will receive 0 marks for the test

  • Please do not congregate outside the halls before & after the test.

  • Place your bags near the door and its surrounding walls

6. Absence from test

  • Anyone with a fever (≥ 38°C), who is unwell or shows respiratory symptoms such as cough and runny nose should see a doctor immediately. Please do not attend the test if you are unwell.

  • For students who have a valid reason for being absent from the test (e.g., student certified by a doctor to be medically unfit to sit for the test, student who is under Stay Home Notice), an alternative test arrangement will be made.

  • Students who are absent without a valid reason will receive zero marks for the test.

7. Test Instructions

  • Students found with unauthorized materials/unauthorized electronic devices will be liable to disciplinary action which may result in his/her expulsion from the University.

  • All mobile phones and devices with communication functions (with the exception of your laptop for taking the test) must be switched off for the entire duration of the test.

  • You are not allowed to bring your mobile phone or any communication device with you when you go to the washroom. Anyone found to have contravened this rule will have their identity noted down for disciplinary action.

  • Place your student card or identification document on the desk

  • You are not allowed to communicate with each other. If you wish to communicate with an invigilator, please raise your hand.

  • You should not leave your seat without the permission of the invigilator.

  • You are not allowed to leave the venue within the first hour and during the last 15 minutes.

  • If you need to leave the venue to go to the washroom, please raise your hand to inform the invigilator.

  • If you have completed the assessment and wish to leave before the end of the assessment, please show the confirmation page on your laptop screen to an invigilator.

  • If a student come unprepared (e.g., forgot to bring laptop, downloaded exam file on another device, etc.), the time taken to resolve these issues shall be borne by the student. Further penalties may be imposed if the student is in possession of the downloaded exam file after the exam has concluded.

  • Students who complete the test must upload the answers before they can leave the venue. It is the student’s responsibility to ensure they have uploaded their answers. If students leave the exam venue without a successful submission, they will be deemed to have submitted empty answer scripts and failed the test concerned.

8. Start of test

  • Chief invigilator will announce the password for test

  • Students can commence on test after unlocking test paper with password

  • Students to place your student card on desk

    • Invigilators will take attendance during test

9. During test

  • To speak to an invigilator, please raise your hand to catch his/her attention

9.1. Asking clarification questions

  • You are allowed to ask only yes/no questions to seek clarifications on questions

  • Inform an invigilator if you need to seek clarification on the test questions

  • Fill in your question on the provided form

questionForm

9.2. Washroom Breaks

  • Request for permission from an invigilator

  • At most one student in each section is allowed to use the washroom at any time

  • You are not allowed to bring any communication device to the washroom

9.3. Technical support for Examplify

  • Inform an invigilator if you require technical support for Examplify

  • There is a team of 5 CIT staff members providing technical support

9.4. Use of charging station

  • Inform an invigilator if you require to use a charging station

10. Finishing early

  • You are not allowed to leave the venue during the first hour & the last 15 minutes of the test

  • If you finish the test after the first hour & before the final 15 minutes, you must show Examplify’s submission confirmation page to an invigilator before you are allowed to leave.

ExamplifyConfirm

11. End of test

  • Chief invigilator will announce the end of the test

  • You are to stop writing and submit your Examplify paper

    • If you’re a latecomer, you must submit even if your timer has not counted down

  • You are to remain seated quietly while the invigilators verify that all answers have been uploaded successfully. You cannot communicate with each other.

  • You are not to leave the venue until you are told to do so.